Node / reticulum_mirror / MeshChatX / files / meshchatx / src / backend / database / auto_recover.py

Displaying Raw • Download

T8b949e# SPDX-License-Identifier: 0BSD

T8b949e"""Pick a compatible on-disk backup and run SQLite recovery when backups are unavailable."""

Tff7b72from T7ee787__future__ Tff7b72import Te6edf3annotations

Tff7b72import T7ee787os

Tff7b72import T7ee787re

Tff7b72import T7ee787tempfile

Tff7b72import T7ee787zipfile

Tff7b72from T7ee787collectionsT7ee787.T7ee787abc Tff7b72import Te6edf3Callable

Tff7b72from T7ee787dataclasses Tff7b72import Te6edf3dataclass

Tff7b72from T7ee787datetime Tff7b72import Te6edf3UTCTb4b4b4, Te6edf3datetime

Tff7b72from T7ee787typing Tff7b72import Te6edf3Any

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787database Tff7b72import Te6edf3DatabaseTb4b4b4, Te6edf3PRE_MIGRATE_BACKUP_PREFIX

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Te6edf3_SUSPICIOUS_RE Tff7b72= Te6edf3reTff7b72.Td2a8ffcompileTb4b4b4(Ta5d6ffrTa5d6ff"Ta5d6ffSUSPICIOUSTa5d6ff"Tb4b4b4, Te6edf3reTff7b72.Td2a8ffITb4b4b4)

Te6edf3_PRE_MIGRATE_VERSION_RE Tff7b72= Te6edf3reTff7b72.Td2a8ffcompileTb4b4b4(

Ta5d6ffrfTa5d6ff"Tffd700{Te6edf3reTff7b72.Td2a8ffescapeTb4b4b4(Te6edf3PRE_MIGRATE_BACKUP_PREFIXTb4b4b4)Tffd700}Ta5d6ffv(Ta5d6ff\Ta5d6ffd+)-to-v(Ta5d6ff\Ta5d6ffd+)Ta5d6ff"Tb4b4b4,

Te6edf3reTff7b72.Td2a8ffITb4b4b4,

Tb4b4b4)

Tf0883e@dataclassTb4b4b4(Te6edf3frozenTff7b72=Tff7b72TrueTb4b4b4)

Tff7b72class T56d364RecoveryBackupCandidateTb4b4b4:

Te6edf3nameTb4b4b4: Tffa657str

Te6edf3pathTb4b4b4: Tffa657str

Te6edf3created_atTb4b4b4: Tffa657str

Te6edf3kindTb4b4b4: Tffa657str

Te6edf3suspiciousTb4b4b4: Tffa657bool

Tff7b72def Td2a8fflist_recovery_backup_candidatesTb4b4b4(Te6edf3storage_pathTb4b4b4: Tffa657strTb4b4b4) Tff7b72-Tff7b72> Tffa657listTb4b4b4[Te6edf3RecoveryBackupCandidateTb4b4b4]Tb4b4b4:

Tff7b72if Tff7b72not Te6edf3storage_pathTb4b4b4:

Tff7b72return Tb4b4b4[Tb4b4b4]

Te6edf3entriesTb4b4b4: Tffa657listTb4b4b4[Te6edf3RecoveryBackupCandidateTb4b4b4] Tff7b72= Tb4b4b4[Tb4b4b4]

Tff7b72for Te6edf3kindTb4b4b4, Te6edf3subdir Tff7b72in Tb4b4b4(Tb4b4b4(Ta5d6ff"Ta5d6ffautoTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffdatabase-backupsTa5d6ff"Tb4b4b4)Tb4b4b4, Tb4b4b4(Ta5d6ff"Ta5d6ffsnapshotTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffsnapshotsTa5d6ff"Tb4b4b4)Tb4b4b4)Tb4b4b4:

Te6edf3directory Tff7b72= Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffjoinTb4b4b4(Te6edf3storage_pathTb4b4b4, Te6edf3subdirTb4b4b4)

Tff7b72if Tff7b72not Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisdirTb4b4b4(Te6edf3directoryTb4b4b4)Tb4b4b4:

Tff7b72continue

Tff7b72for Te6edf3name Tff7b72in Te6edf3osTff7b72.Td2a8fflistdirTb4b4b4(Te6edf3directoryTb4b4b4)Tb4b4b4:

Tff7b72if Tff7b72not Te6edf3nameTff7b72.Td2a8ffendswithTb4b4b4(Ta5d6ff"Ta5d6ff.zipTa5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72continue

Te6edf3full_path Tff7b72= Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffjoinTb4b4b4(Te6edf3directoryTb4b4b4, Te6edf3nameTb4b4b4)

Tff7b72if Tff7b72not Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisfileTb4b4b4(Te6edf3full_pathTb4b4b4)Tb4b4b4:

Tff7b72continue

Te6edf3stats Tff7b72= Te6edf3osTff7b72.Td2a8ffstatTb4b4b4(Te6edf3full_pathTb4b4b4)

Te6edf3entriesTff7b72.Td2a8ffappendTb4b4b4(

Te6edf3RecoveryBackupCandidateTb4b4b4(

Te6edf3nameTff7b72=Te6edf3nameTb4b4b4,

Te6edf3pathTff7b72=Te6edf3full_pathTb4b4b4,

Te6edf3created_atTff7b72=Te6edf3datetimeTff7b72.Td2a8fffromtimestampTb4b4b4(Te6edf3statsTff7b72.Td2a8ffst_mtimeTb4b4b4, Te6edf3UTCTb4b4b4)Tff7b72.Td2a8ffisoformatTb4b4b4(Tb4b4b4)Tb4b4b4,

Te6edf3kindTff7b72=Te6edf3kindTb4b4b4,

Te6edf3suspiciousTff7b72=Tffa657boolTb4b4b4(Te6edf3_SUSPICIOUS_RETff7b72.Td2a8ffsearchTb4b4b4(Te6edf3nameTb4b4b4)Tb4b4b4)Tb4b4b4,

Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72return Tffa657sortedTb4b4b4(Te6edf3entriesTb4b4b4, Te6edf3keyTff7b72=Tff7b72lambda Te6edf3rowTb4b4b4: Te6edf3rowTff7b72.Td2a8ffcreated_atTb4b4b4, Te6edf3reverseTff7b72=Tff7b72TrueTb4b4b4)

Tff7b72def Td2a8ffread_schema_version_from_db_pathTb4b4b4(Te6edf3db_pathTb4b4b4: Tffa657strTb4b4b4) Tff7b72-Tff7b72> Tffa657int Tff7b72| Tff7b72NoneTb4b4b4:

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Te6edf3db_pathTb4b4b4)

Tff7b72tryTb4b4b4:

Te6edf3row Tff7b72= Te6edf3providerTff7b72.Td2a8fffetchoneTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT value FROM config WHERE key = ?Ta5d6ff"Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6ffdatabase_versionTa5d6ff"Tb4b4b4,Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72if Tff7b72not Te6edf3rowTb4b4b4:

Tff7b72return T79c0ff0

Tff7b72return Tffa657intTb4b4b4(Te6edf3rowTb4b4b4[Ta5d6ff"Ta5d6ffvalueTa5d6ff"Tb4b4b4]Tb4b4b4)

Tff7b72except Tb4b4b4(Tf85149TypeErrorTb4b4b4, Tf85149ValueErrorTb4b4b4)Tb4b4b4:

Tff7b72return Tff7b72None

Tff7b72except Tf85149ExceptionTb4b4b4:

Tff7b72return Tff7b72None

Tff7b72finallyTb4b4b4:

Te6edf3providerTff7b72.Td2a8ffclose_allTb4b4b4(Tb4b4b4)

Tff7b72def Td2a8ffinfer_version_hint_from_backup_nameTb4b4b4(Te6edf3nameTb4b4b4: Tffa657strTb4b4b4) Tff7b72-Tff7b72> Tffa657int Tff7b72| Tff7b72NoneTb4b4b4:

T8b949e"""Return the schema version stored in a pre-migrate zip (the from version)."""

Te6edf3match Tff7b72= Te6edf3_PRE_MIGRATE_VERSION_RETff7b72.Td2a8ffsearchTb4b4b4(Te6edf3nameTb4b4b4)

Tff7b72if Tff7b72not Te6edf3matchTb4b4b4:

Tff7b72return Tff7b72None

Tff7b72tryTb4b4b4:

Tff7b72return Tffa657intTb4b4b4(Te6edf3matchTff7b72.Td2a8ffgroupTb4b4b4(T79c0ff1Tb4b4b4)Tb4b4b4)

Tff7b72except Tf85149ValueErrorTb4b4b4:

Tff7b72return Tff7b72None

Tff7b72def Td2a8ffschema_version_restorableTb4b4b4(Te6edf3versionTb4b4b4: Tffa657int Tff7b72| Tff7b72NoneTb4b4b4, Te6edf3latest_schema_versionTb4b4b4: Tffa657intTb4b4b4) Tff7b72-Tff7b72> Tffa657boolTb4b4b4:

Tff7b72if Te6edf3version Tff7b72is Tff7b72NoneTb4b4b4:

Tff7b72return Tff7b72False

Tff7b72return T79c0ff0 Tff7b72<Tff7b72= Te6edf3version Tff7b72<Tff7b72= Te6edf3latest_schema_version

Tff7b72def Td2a8ff_quick_check_labelTb4b4b4(Te6edf3providerTb4b4b4: Te6edf3DatabaseProviderTb4b4b4) Tff7b72-Tff7b72> Tffa657strTb4b4b4:

Te6edf3rows Tff7b72= Te6edf3providerTff7b72.Td2a8ffquick_checkTb4b4b4(Tb4b4b4)

Tff7b72if Tff7b72not Te6edf3rowsTb4b4b4:

Tff7b72return Ta5d6ff"Ta5d6ffunknownTa5d6ff"

Te6edf3first Tff7b72= Te6edf3rowsTb4b4b4[T79c0ff0Tb4b4b4]

Tff7b72if Tffa657isinstanceTb4b4b4(Te6edf3firstTb4b4b4, Tffa657dictTb4b4b4)Tb4b4b4:

Tff7b72return Tffa657strTb4b4b4(Tffa657nextTb4b4b4(Tffa657iterTb4b4b4(Te6edf3firstTff7b72.Td2a8ffvaluesTb4b4b4(Tb4b4b4)Tb4b4b4)Tb4b4b4)Tb4b4b4)

Tff7b72return Tffa657strTb4b4b4(Te6edf3firstTb4b4b4[T79c0ff0Tb4b4b4]Tb4b4b4)

Tff7b72def Td2a8ff_find_primary_db_memberTb4b4b4(Te6edf3zfTb4b4b4: Te6edf3zipfileTff7b72.Td2a8ffZipFileTb4b4b4) Tff7b72-Tff7b72> Tffa657str Tff7b72| Tff7b72NoneTb4b4b4:

Te6edf3membersTb4b4b4: Tffa657listTb4b4b4[Tffa657strTb4b4b4] Tff7b72= Tb4b4b4[Tb4b4b4]

Tff7b72for Te6edf3member Tff7b72in Te6edf3zfTff7b72.Td2a8ffnamelistTb4b4b4(Tb4b4b4)Tb4b4b4:

Tff7b72if Te6edf3memberTff7b72.Td2a8ffendswithTb4b4b4(Ta5d6ff"Ta5d6ff/Ta5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72continue

Te6edf3base Tff7b72= Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffbasenameTb4b4b4(Te6edf3memberTb4b4b4)

Tff7b72if Te6edf3baseTff7b72.Td2a8ffendswithTb4b4b4(Ta5d6ff"Ta5d6ff.dbTa5d6ff"Tb4b4b4) Tff7b72and Tff7b72not Te6edf3baseTff7b72.Td2a8ffendswithTb4b4b4(Tb4b4b4(Ta5d6ff"Ta5d6ff-walTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ff-shmTa5d6ff"Tb4b4b4)Tb4b4b4)Tb4b4b4:

Te6edf3membersTff7b72.Td2a8ffappendTb4b4b4(Te6edf3memberTb4b4b4)

Tff7b72if Tff7b72not Te6edf3membersTb4b4b4:

Tff7b72return Tff7b72None

Tff7b72return Tffa657sortedTb4b4b4(Te6edf3membersTb4b4b4, Te6edf3keyTff7b72=Tff7b72lambda Te6edf3nameTb4b4b4: Te6edf3nameTff7b72.Td2a8ffcountTb4b4b4(Ta5d6ff"Ta5d6ff/Ta5d6ff"Tb4b4b4)Tb4b4b4)Tb4b4b4[T79c0ff0Tb4b4b4]

Tff7b72def Td2a8ffprobe_backup_zipTb4b4b4(Te6edf3zip_pathTb4b4b4: Tffa657strTb4b4b4) Tff7b72-Tff7b72> Tffa657dictTb4b4b4[Tffa657strTb4b4b4, Te6edf3AnyTb4b4b4]Tb4b4b4:

Tff7b72if Tff7b72not Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisfileTb4b4b4(Te6edf3zip_pathTb4b4b4)Tb4b4b4:

Tff7b72return Tb4b4b4{Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbackup file not foundTa5d6ff"Tb4b4b4}

Tff7b72if Tff7b72not Te6edf3zipfileTff7b72.Td2a8ffis_zipfileTb4b4b4(Te6edf3zip_pathTb4b4b4)Tb4b4b4:

Tff7b72return Tb4b4b4{Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffnot a zip backupTa5d6ff"Tb4b4b4}

Tff7b72with Te6edf3tempfileTff7b72.Td2a8ffTemporaryDirectoryTb4b4b4(Te6edf3prefixTff7b72=Ta5d6ff"Ta5d6ffmeshchatx-backup-probe-Ta5d6ff"Tb4b4b4) Tff7b72as Te6edf3tmpTb4b4b4:

Tff7b72tryTb4b4b4:

Tff7b72with Te6edf3zipfileTff7b72.Td2a8ffZipFileTb4b4b4(Te6edf3zip_pathTb4b4b4, Ta5d6ff"Ta5d6ffrTa5d6ff"Tb4b4b4) Tff7b72as Te6edf3zfTb4b4b4:

Te6edf3member Tff7b72= Te6edf3_find_primary_db_memberTb4b4b4(Te6edf3zfTb4b4b4)

Tff7b72if Tff7b72not Te6edf3memberTb4b4b4:

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffno database file in backupTa5d6ff"Tb4b4b4,

Tb4b4b4}

Te6edf3DatabaseTff7b72.Td2a8ff_safe_zip_extract_memberTb4b4b4(Te6edf3zfTb4b4b4, Te6edf3memberTb4b4b4, Te6edf3tmpTb4b4b4)

Te6edf3db_path Tff7b72= Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffjoinTb4b4b4(Te6edf3tmpTb4b4b4, Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffbasenameTb4b4b4(Te6edf3memberTb4b4b4)Tb4b4b4)

Tff7b72if Tff7b72not Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisfileTb4b4b4(Te6edf3db_pathTb4b4b4)Tb4b4b4:

Te6edf3foundTb4b4b4: Tffa657str Tff7b72| Tff7b72None Tff7b72= Tff7b72None

Tff7b72for Te6edf3rootTb4b4b4, Te6edf3_Tb4b4b4, Te6edf3files Tff7b72in Te6edf3osTff7b72.Td2a8ffwalkTb4b4b4(Te6edf3tmpTb4b4b4)Tb4b4b4:

Tff7b72for Te6edf3name Tff7b72in Te6edf3filesTb4b4b4:

Tff7b72if Te6edf3nameTff7b72.Td2a8ffendswithTb4b4b4(Ta5d6ff"Ta5d6ff.dbTa5d6ff"Tb4b4b4) Tff7b72and Tff7b72not Te6edf3nameTff7b72.Td2a8ffendswithTb4b4b4(Tb4b4b4(Ta5d6ff"Ta5d6ff-walTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ff-shmTa5d6ff"Tb4b4b4)Tb4b4b4)Tb4b4b4:

Te6edf3found Tff7b72= Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffjoinTb4b4b4(Te6edf3rootTb4b4b4, Te6edf3nameTb4b4b4)

Tff7b72break

Tff7b72if Te6edf3foundTb4b4b4:

Tff7b72break

Te6edf3db_path Tff7b72= Te6edf3found

Tff7b72if Tff7b72not Te6edf3db_path Tff7b72or Tff7b72not Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisfileTb4b4b4(Te6edf3db_pathTb4b4b4)Tb4b4b4:

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffextracted database missingTa5d6ff"Tb4b4b4,

Tb4b4b4}

Te6edf3version Tff7b72= Te6edf3read_schema_version_from_db_pathTb4b4b4(Te6edf3db_pathTb4b4b4)

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Te6edf3db_pathTb4b4b4)

Tff7b72tryTb4b4b4:

Te6edf3quick_check Tff7b72= Te6edf3_quick_check_labelTb4b4b4(Te6edf3providerTb4b4b4)

Tff7b72finallyTb4b4b4:

Te6edf3providerTff7b72.Td2a8ffclose_allTb4b4b4(Tb4b4b4)

Tff7b72return Tb4b4b4{Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Te6edf3versionTb4b4b4, Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Te6edf3quick_checkTb4b4b4, Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4}

Tff7b72except Tf85149Exception Tff7b72as Te6edf3excTb4b4b4:

Tff7b72return Tb4b4b4{Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4, Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Tffa657strTb4b4b4(Te6edf3excTb4b4b4)Tb4b4b4}

Tff7b72def Td2a8ffpick_compatible_backupTb4b4b4(

Te6edf3storage_pathTb4b4b4: Tffa657strTb4b4b4,

Te6edf3latest_schema_versionTb4b4b4: Tffa657intTb4b4b4,

Tb4b4b4) Tff7b72-Tff7b72> Tffa657dictTb4b4b4[Tffa657strTb4b4b4, Te6edf3AnyTb4b4b4] Tff7b72| Tff7b72NoneTb4b4b4:

Te6edf3candidates Tff7b72= Te6edf3list_recovery_backup_candidatesTb4b4b4(Te6edf3storage_pathTb4b4b4)

Te6edf3healthy Tff7b72= Tb4b4b4[Te6edf3row Tff7b72for Te6edf3row Tff7b72in Te6edf3candidates Tff7b72if Tff7b72not Te6edf3rowTff7b72.Td2a8ffsuspiciousTb4b4b4]

Te6edf3ordered Tff7b72= Te6edf3healthy Tff7b72if Te6edf3healthy Tff7b72else Tffa657listTb4b4b4(Te6edf3candidatesTb4b4b4)

Tff7b72for Te6edf3candidate Tff7b72in Te6edf3orderedTb4b4b4:

Te6edf3probe Tff7b72= Te6edf3probe_backup_zipTb4b4b4(Te6edf3candidateTff7b72.Td2a8ffpathTb4b4b4)

Tff7b72if Te6edf3probeTff7b72.Td2a8ffgetTb4b4b4(Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4)Tb4b4b4:

Tff7b72continue

Te6edf3version Tff7b72= Te6edf3probeTff7b72.Td2a8ffgetTb4b4b4(Ta5d6ff"Ta5d6ffversionTa5d6ff"Tb4b4b4)

Tff7b72if Te6edf3version Tff7b72is Tff7b72NoneTb4b4b4:

Te6edf3version Tff7b72= Te6edf3infer_version_hint_from_backup_nameTb4b4b4(Te6edf3candidateTff7b72.Td2a8ffnameTb4b4b4)

Tff7b72if Tff7b72not Te6edf3schema_version_restorableTb4b4b4(Te6edf3versionTb4b4b4, Te6edf3latest_schema_versionTb4b4b4)Tb4b4b4:

Tff7b72continue

Te6edf3quick_check Tff7b72= Te6edf3probeTff7b72.Td2a8ffgetTb4b4b4(Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4)

Tff7b72if Te6edf3quick_check Tff7b72!= Ta5d6ff"Ta5d6ffokTa5d6ff"Tb4b4b4:

Tff7b72continue

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffnameTa5d6ff"Tb4b4b4: Te6edf3candidateTff7b72.Td2a8ffnameTb4b4b4,

Ta5d6ff"Ta5d6ffpathTa5d6ff"Tb4b4b4: Te6edf3candidateTff7b72.Td2a8ffpathTb4b4b4,

Ta5d6ff"Ta5d6ffkindTa5d6ff"Tb4b4b4: Te6edf3candidateTff7b72.Td2a8ffkindTb4b4b4,

Ta5d6ff"Ta5d6ffdatabase_versionTa5d6ff"Tb4b4b4: Te6edf3versionTb4b4b4,

Ta5d6ff"Ta5d6ffquick_checkTa5d6ff"Tb4b4b4: Te6edf3quick_checkTb4b4b4,

Ta5d6ff"Ta5d6ffsuspiciousTa5d6ff"Tb4b4b4: Te6edf3candidateTff7b72.Td2a8ffsuspiciousTb4b4b4,

Tb4b4b4}

Tff7b72return Tff7b72None

Tff7b72def Td2a8ffrun_auto_database_recoverTb4b4b4(

Te6edf3storage_pathTb4b4b4: Tffa657strTb4b4b4,

Te6edf3db_pathTb4b4b4: Tffa657str Tff7b72| Tff7b72NoneTb4b4b4,

Te6edf3latest_schema_versionTb4b4b4: Tffa657intTb4b4b4,

Te6edf3restore_fnTb4b4b4: Te6edf3CallableTb4b4b4[Tb4b4b4[Tffa657strTb4b4b4]Tb4b4b4, Tffa657dictTb4b4b4]Tb4b4b4,

Te6edf3sqlite_recover_fnTb4b4b4: Te6edf3CallableTb4b4b4[Tb4b4b4[Tb4b4b4]Tb4b4b4, Tffa657dictTb4b4b4] Tff7b72| Tff7b72None Tff7b72= Tff7b72NoneTb4b4b4,

Tb4b4b4) Tff7b72-Tff7b72> Tffa657dictTb4b4b4[Tffa657strTb4b4b4, Te6edf3AnyTb4b4b4]Tb4b4b4:

Te6edf3picked Tff7b72= Te6edf3pick_compatible_backupTb4b4b4(Te6edf3storage_pathTb4b4b4, Te6edf3latest_schema_versionTb4b4b4)

Tff7b72if Te6edf3pickedTb4b4b4:

Te6edf3restore_result Tff7b72= Te6edf3restore_fnTb4b4b4(Te6edf3pickedTb4b4b4[Ta5d6ff"Ta5d6ffpathTa5d6ff"Tb4b4b4]Tb4b4b4)

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffstrategyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffrestore_backupTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffmessageTa5d6ff"Tb4b4b4: Ta5d6fffTa5d6ff"Ta5d6ffRestored database from Tffd700{Te6edf3pickedTb4b4b4[Ta5d6ff'Ta5d6ffnameTa5d6ff'Tb4b4b4]Tffd700}Ta5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffbackupTa5d6ff"Tb4b4b4: Te6edf3pickedTb4b4b4,

Ta5d6ff"Ta5d6ffrequires_relaunchTa5d6ff"Tb4b4b4: Tff7b72TrueTb4b4b4,

Ta5d6ff"Ta5d6ffrestore_resultTa5d6ff"Tb4b4b4: Te6edf3restore_resultTb4b4b4,

Tb4b4b4}

Tff7b72if Te6edf3sqlite_recover_fn Tff7b72is Tff7b72not Tff7b72None Tff7b72and Te6edf3db_path Tff7b72and Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffisfileTb4b4b4(Te6edf3db_pathTb4b4b4)Tb4b4b4:

Tff7b72tryTb4b4b4:

Te6edf3recovery Tff7b72= Te6edf3sqlite_recover_fnTb4b4b4(Tb4b4b4)

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffstrategyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffsqlite_recoveryTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffmessageTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffSQLite recovery routine completed on the live databaseTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffrequires_relaunchTa5d6ff"Tb4b4b4: Tff7b72FalseTb4b4b4,

Ta5d6ff"Ta5d6ffdatabaseTa5d6ff"Tb4b4b4: Te6edf3recoveryTb4b4b4,

Tb4b4b4}

Tff7b72except Tf85149Exception Tff7b72as Te6edf3excTb4b4b4:

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffstrategyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffnoneTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffmessageTa5d6ff"Tb4b4b4: Tb4b4b4(

Ta5d6ff"Ta5d6ffNo compatible automatic backup was found and SQLite recovery failedTa5d6ff"

Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6ffrequires_relaunchTa5d6ff"Tb4b4b4: Tff7b72FalseTb4b4b4,

Ta5d6ff"Ta5d6fferrorTa5d6ff"Tb4b4b4: Tffa657strTb4b4b4(Te6edf3excTb4b4b4)Tb4b4b4,

Tb4b4b4}

Tff7b72return Tb4b4b4{

Ta5d6ff"Ta5d6ffstrategyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffnoneTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffmessageTa5d6ff"Tb4b4b4: Tb4b4b4(

Ta5d6ff"Ta5d6ffNo compatible automatic backup was found. Use Restore from file or Ta5d6ff"

Ta5d6ff"Ta5d6ffpick a snapshot manually.Ta5d6ff"

Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6ffrequires_relaunchTa5d6ff"Tb4b4b4: Tff7b72FalseTb4b4b4,

Tb4b4b4}